UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9r7+6wzOcZ8+yxetAOyLXexgPbLKEWgFXEKs8abZet0='
WHERE
key_id = 'f509ddb3cc5fe83110e8a7048f2fed45b6d486ee074da88ba36710067df89ffd'
AND (
token = '9r7+6wzOcZ8+yxetAOyLXexgPbLKEWgFXEKs8abZet0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)