UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bgkcx5iR0DY7km6NJKFicdf+p5rPL0u/UPC5g28w/Wg='
WHERE
key_id = 'f6f36467f216690ba31aa7d56b2217540774e497e7585acaf8b485d02290443b'
AND (
token = 'bgkcx5iR0DY7km6NJKFicdf+p5rPL0u/UPC5g28w/Wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)