UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i9sExJ0H6AQakLQ/L/XxMYBOuUGTCJk8Wp7BPEAn0PA='
WHERE
key_id = 'c466f9fee793bf60c6f4b71b70642a8158027bb23e8b6c8c32f16a643f7c6290'
AND (
token = 'i9sExJ0H6AQakLQ/L/XxMYBOuUGTCJk8Wp7BPEAn0PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)