UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uMxAQtemg5kfCdIKvW8Op3ZBXJ7OZ5zXPZgAV9t8YF0='
WHERE
key_id = '4fb30401a9e7cceb84c1adca5493902247e2887369aa102fb6af572072ec9485'
AND (
token = 'uMxAQtemg5kfCdIKvW8Op3ZBXJ7OZ5zXPZgAV9t8YF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)