UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgpvNWZcNzvn4mLonP0pk6i6HtyXXF9KOiCfyJJHmMw='
WHERE
key_id = '4c91fd5a6099166741e97d64c0a7e55714802e39d597088e2c587553dd11b892'
AND (
token = 'ZgpvNWZcNzvn4mLonP0pk6i6HtyXXF9KOiCfyJJHmMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)