UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhSS8DyYjTDgZu7iXyEaPi01aqAZhZECMFgj2j1+gPo='
WHERE
key_id = 'e25c235ac2ba68dc1766f635c5165cd67a7fe4e2281b426f1bdcd4fbe917551c'
AND (
token = 'BhSS8DyYjTDgZu7iXyEaPi01aqAZhZECMFgj2j1+gPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)