UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyFCy2cXWvkc5ECptRFFhyhUz8BcwtpHSyQiDCVNExE='
WHERE
key_id = '87e17f019b842f17ff64563c2170cc30d7b701715c96ef0781e2ac8529cff480'
AND (
token = 'ZyFCy2cXWvkc5ECptRFFhyhUz8BcwtpHSyQiDCVNExE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)