UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCHOMmBDIFC46RWwUkBhm8PL3uu+YQvIWtXQrPHwxhs='
WHERE
key_id = 'debc54aad3dbdd50a0033d51c78d8b1da1e764aee343889633ec0d4981ab4e30'
AND (
token = 'bCHOMmBDIFC46RWwUkBhm8PL3uu+YQvIWtXQrPHwxhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)