UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aYXAyys8jBPoIPBeoHuCErkDsVgB0MT8W5E+f170JYw='
WHERE
key_id = '502c3fc5b12bad18473d97dcb480f37a77eefe45fdca14e5ad9f5a105fe4e3a7'
AND (
token = 'aYXAyys8jBPoIPBeoHuCErkDsVgB0MT8W5E+f170JYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)