UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIVkfK8ZGfznA2x/2xb5zx4qOjK0D60isUBEayr/bbw='
WHERE
key_id = 'ca0aeb9f099fd44699fb0240929d0e6f21a7e977b20bb40ea92f5b8c6967e4b9'
AND (
token = 'XIVkfK8ZGfznA2x/2xb5zx4qOjK0D60isUBEayr/bbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)