UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nvdEd9MPWM6BDlWzVkMmnIbBUp/pBiKiIP2W1I9DLIw='
WHERE
key_id = '296a972f356e072f846bfaea757788dc13feabf79ace5b6ecbb615487908dff6'
AND (
token = 'nvdEd9MPWM6BDlWzVkMmnIbBUp/pBiKiIP2W1I9DLIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)