UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HiiEJ2wbqaKbtzFBtashfBzbKALiuk/VzSiU5f8kU+E='
WHERE
key_id = 'aad305112f61eab6cc27f6d48eae6c6c4a8107df8f62ff21db04c8ebe86f2899'
AND (
token = 'HiiEJ2wbqaKbtzFBtashfBzbKALiuk/VzSiU5f8kU+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)