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