UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8HGUAcWeFnY7dBYFYTsJpuWgIoDepBex8BN1EOBqmA='
WHERE
key_id = 'bd0999922d13198b3463ffa4f9f36b2f0f115e82ac3fd14af07dac332d98f412'
AND (
token = 'R8HGUAcWeFnY7dBYFYTsJpuWgIoDepBex8BN1EOBqmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)