UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2GhCn6gFFbnIvaQfWQs0PJHbQYuF+o9xDJkSuVdMwuA='
WHERE
key_id = '97ea7116b83313462d5ed88c165efaba9c92eb9cb04381a46089fad993271a31'
AND (
token = '2GhCn6gFFbnIvaQfWQs0PJHbQYuF+o9xDJkSuVdMwuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)