UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOktJew66ObgewSw5mwIKjxfgax1U7JMdh1BXhH0ey4='
WHERE
key_id = '0386d70d8ac3cc6f04d01296159930d2177bf23927cc5c433dab3fe1cd25798f'
AND (
token = 'HOktJew66ObgewSw5mwIKjxfgax1U7JMdh1BXhH0ey4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)