UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mhtSzrDycn1+SAelQH+7j0n7vIgdsSaiXgFeH8S04BQ=' 
WHERE 
  key_id = '508e590a678fbcfb55f8804c7e12c450db777042b4166a1fb07df833cac8cda9' 
  AND (
    token = 'mhtSzrDycn1+SAelQH+7j0n7vIgdsSaiXgFeH8S04BQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034