UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jbd7CeXVv3Jgf3gYxYJWklHpiDBoBxshXZ2WOm8g2Ks='
WHERE
key_id = 'a5a9322643ff8a0d65a42acd090eba3c48afe5ec6c6c7842c3365c811789560a'
AND (
token = 'Jbd7CeXVv3Jgf3gYxYJWklHpiDBoBxshXZ2WOm8g2Ks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)