UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtSHYpyrwmQK8J8xU7aJ3RYhQ0t7/H4deNcrSpzYR1o='
WHERE
key_id = '06a237e330c0e9faedcfba59eec65f1a05bf9342d01adfc0a90280fd41b9ffa7'
AND (
token = 'XtSHYpyrwmQK8J8xU7aJ3RYhQ0t7/H4deNcrSpzYR1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)