UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2G/eMxvqxTotB9sl58uaCzHgXN+6Uc21sCgkZHiNnKA='
WHERE
key_id = 'f99ca4aae467ee36abb8cfe4482ad68150585f684527f6b8a542085579f7f8ed'
AND (
token = '2G/eMxvqxTotB9sl58uaCzHgXN+6Uc21sCgkZHiNnKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)