UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bQQkhkJU/pcz2ic1aJuC03u8Zk3Y/UuVkhDU57CNTwI='
WHERE
key_id = 'c9072c8711efec8223b450bee7bfa3d11171f48d817e855fdb3570a116002e1d'
AND (
token = 'bQQkhkJU/pcz2ic1aJuC03u8Zk3Y/UuVkhDU57CNTwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)