UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZri2J5FYQfDelof/rRDMdV6KQmuVC5Q5M4uh7sL50U='
WHERE
key_id = '75efeb070d82542aea9611410459af2c4adb90e58b7c1eb9199f6df834ea0534'
AND (
token = 'gZri2J5FYQfDelof/rRDMdV6KQmuVC5Q5M4uh7sL50U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)