UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5GX8kAJ7UlGLx3tLwcQLWDg0/TwhzDw6PNYvwltO35A='
WHERE
key_id = 'e5e4bb5a4f1e9c26987ad27eccffcca263a39f83a18f6ce7bf3117e2873380ad'
AND (
token = '5GX8kAJ7UlGLx3tLwcQLWDg0/TwhzDw6PNYvwltO35A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)