UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yRwMC97qy7LYVI6EpZOzz+/9cR2CJfuW1mip55GxSB4='
WHERE
key_id = '9f720ba6d36c6296ab2ea9e688a653387e320014e8dcfd45c1960f61e7f85b77'
AND (
token = 'yRwMC97qy7LYVI6EpZOzz+/9cR2CJfuW1mip55GxSB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)