UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jp9RgYihTHAGviAeAaaCVeMiUNHYHp8EDPIO2RuAHo='
WHERE
key_id = 'ed471b8af50bd30683f3e98a4bfc1eb2bb4cc7f6080ab3cad92c7d4b3cdf529a'
AND (
token = '4jp9RgYihTHAGviAeAaaCVeMiUNHYHp8EDPIO2RuAHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)