UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vP7Jmk4HAHObUG/G1FrHbdsZEcTyT77RKGZH2vLwIs='
WHERE
key_id = '07efae25638f8d96235d53408f74ca80db950f23e42fceb2fc114d8a85b2e680'
AND (
token = '9vP7Jmk4HAHObUG/G1FrHbdsZEcTyT77RKGZH2vLwIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)