UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0rN07ecvv56puOsDsFAXRlpr4h87yIa7fYb93r/hMAc='
WHERE
key_id = 'e34d3ccc7e63982e7c3619288f76322c8dfb6eebe82c9295189c6d1173ae2dca'
AND (
token = '0rN07ecvv56puOsDsFAXRlpr4h87yIa7fYb93r/hMAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)