UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EmXdQxFQbpirE91bIGhX4L4XvFxgr02R6MydYjLx8sc='
WHERE
key_id = '94abcb10512ff31dac3efd2c71eec07e0e311c3c93459f634026bf00abee1887'
AND (
token = 'EmXdQxFQbpirE91bIGhX4L4XvFxgr02R6MydYjLx8sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)