UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sjTcZYF56a8KL8mBIeF9B5zFMkkivxP/vuU+9cQ2M40='
WHERE
key_id = 'cfcc7cd0315cf3bb1cd209c778d80a052a9922503cbe202c7d10f49342d3a8eb'
AND (
token = 'sjTcZYF56a8KL8mBIeF9B5zFMkkivxP/vuU+9cQ2M40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)