UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hBQAQjs5WXzpcdxss0rHl+XF/Di1vjszCghuEZY1IaU='
WHERE
key_id = 'e568fe75d4a46daee031952a6eade54ae88cda892dd245271f8ef60bbd7c3ef7'
AND (
token = 'hBQAQjs5WXzpcdxss0rHl+XF/Di1vjszCghuEZY1IaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)