UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CCqXwf9C5ZTzrtzlCCtEgSkSJcjsBS1yuWl0m5Uv6co=' 
WHERE 
  key_id = '606274ed5aef499daa7a7a80b8f068cc4f390e6b58eaa97956be965ca8d6fa2f' 
  AND (
    token = 'CCqXwf9C5ZTzrtzlCCtEgSkSJcjsBS1yuWl0m5Uv6co=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020