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