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