UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4TRDhTFqK6NiMpByWXHdK93Wr/Iw96mh03qUdot7emE='
WHERE
key_id = 'b7e754c2465c6ed936ac5780fef40fa46ef11da925e25efde44e49600fc1644e'
AND (
token = '4TRDhTFqK6NiMpByWXHdK93Wr/Iw96mh03qUdot7emE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)