UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8seoZSWUJrNxgfeY2PR5txD8kY6u7FM3OS/SbI/gi38='
WHERE
key_id = '78b623348039b02df7df112eba3034b8fba9d7a257e394fd9c66154c9c1fc750'
AND (
token = '8seoZSWUJrNxgfeY2PR5txD8kY6u7FM3OS/SbI/gi38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)