UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SrTbF4OQOWc7G/2UCWepmb/zxF1o3CjudcdyhkHm1hI='
WHERE
key_id = '9d3afca6940d5f2687707ec594b3aa3b56f461d46a218eaafa969bf60565c59d'
AND (
token = 'SrTbF4OQOWc7G/2UCWepmb/zxF1o3CjudcdyhkHm1hI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)