UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WzSh4PwbuIUFPOzGU5+3Z/UuH6fHlsEaQ5jjfr1JY0w='
WHERE
key_id = '2ac28deea581f01566ce97c74f96e5bf4c340c4693b1d8ca788aa6a50ff7f8ac'
AND (
token = 'WzSh4PwbuIUFPOzGU5+3Z/UuH6fHlsEaQ5jjfr1JY0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)