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