UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4q5Pf3ztPtc+zteMsordD/m+cgGj9Wa17qtqBQl0zqI=' 
WHERE 
  key_id = '246531ba4767f3c7995f1a43c00c084897ef89574d511f5400c1a08ce40d364f' 
  AND (
    token = '4q5Pf3ztPtc+zteMsordD/m+cgGj9Wa17qtqBQl0zqI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039