UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9h6+pQaeIiJKS1SOI5vtIzw5IHFZykHySayaO7jsE+4='
WHERE
key_id = '5cc9f757a102111d94920edf16718d48427d1c1f4d4bb0d04dbf867ed6f44df6'
AND (
token = '9h6+pQaeIiJKS1SOI5vtIzw5IHFZykHySayaO7jsE+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)