UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0z7oGRBB+vTKvhmLFm7+As+sa/NfSHYOu4Epj/pAze8='
WHERE
key_id = 'aab865e1c1c8dbe2629b79a1654f4e05d6d927c2b313a80e2a9ee96b24e65ff0'
AND (
token = '0z7oGRBB+vTKvhmLFm7+As+sa/NfSHYOu4Epj/pAze8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)