UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VqNmNrt2NZUN+1Hbex3lUgZ7ddVDHcSe4j64JiOrGk='
WHERE
key_id = '873512ea3115d7e41c417e42cfcc2b80b64201c8bba6ae076255c30e5b2c07fb'
AND (
token = '9VqNmNrt2NZUN+1Hbex3lUgZ7ddVDHcSe4j64JiOrGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)