UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8ozTeEMHjkYFLmkUrE4ndJiRPiSdIrNGB7I/pUTgWQ='
WHERE
key_id = 'bc876f98acc97730f7ed36c049d0364718dc65522822ae9a54ad836c7d892220'
AND (
token = 'p8ozTeEMHjkYFLmkUrE4ndJiRPiSdIrNGB7I/pUTgWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)