UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DbkfX5wmjhxk50jszdQxJG4K8gV9VdNgWxQ159Ot/MU='
WHERE
key_id = 'bf6c4776f176e694dfab17e9ac5d996bf4172cfcefc2203b7c79acf64437b54f'
AND (
token = 'DbkfX5wmjhxk50jszdQxJG4K8gV9VdNgWxQ159Ot/MU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)