UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mLhZd4TXtyuwAp23UC2YYsgdAbTQtRnarm2UHKqa/EI='
WHERE
key_id = '6f6182afe22319d2281a535698f497847b6864f1ad20bdf41a7df018d3e759c9'
AND (
token = 'mLhZd4TXtyuwAp23UC2YYsgdAbTQtRnarm2UHKqa/EI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)